Creating Staging and Population Cont'd 8
Stage 1: Extract Data from the JSON and Excel Source to Staging Area
1. Create a variable for JSON file path [JSONFILEPATH]
2. Drag and drop Execute SQL Task from the SSIS Toolbox onto the canvas
Configure the Execute SQL Task to initialize the staging tables by truncating all previous data by providing the query and screenshot above in the SQL Statement Tab.
1.
2. 3. Configure Script Component Task to read and load JSON file
C# Script for Consumers.cs and Main.cs are in ScriptComponentScript folder
3.
w
4. Use Foreach Loop Container to load multiple JSON files
5. Drag and drop the Data Flow Task from the SSIS Toolbox onto the canvas. Double-click to enter the edit mode in the Data Flow Task. Drag and Drop OLE DB source and destination tasks for 2 tables as shown in the screenshot below for the following tables:
· tbl_Stg_ComplainantGrouping
· tbl_Stg_ComplainantCRScore